package com.model;

import java.util.List;

import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Model;
import com.jfinal.plugin.activerecord.Record;

public class Thesistitle extends Model<Thesistitle>{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	public static final Thesistitle dao= new Thesistitle();
	
	/**
	 * 查看学生是否符合论文申报的状态
	 * @param stuId
	 * @return
	 */
	public String checkState(int stuId)
	{	
		String sql="SELECT thesistitle_checkstate from thesistitle WHERE thesistitle_id = "
				+ "(SELECT stu_rela_thesis_thesis from student_rela_thesistitle WHERE stu_rela_thesis_stu ="+stuId+")";
		String state=Db.queryStr(sql);
		return state;
	}

}
